Calculate accurate work duration in Excel by subtracting clock times and formatting cells as [h]:mm to display totals exceeding 24 hours.